<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( "../../global/initialize.php");

if( isset( $_POST[ 'name' ] ) && isset( $_POST[ 'tag' ] ) && formatInput( $_POST[ 'name' ] ) != "" && formatInput( $_POST[ 'tag' ] ) != "" ) {
    $faction_name = formatInput( $_POST[ 'name' ] );
    if( strlen( $faction_name ) > 50 ) {
    	$faction_name = substr( $faction_name, 0, 50 );
    }
    $faction_tag = formatInput( $_POST[ 'tag' ] );
    if( strlen( $faction_tag ) > 5 ) {
    	$faction_tag = substr( $faction_tag, 0, 5 );
    }
    $query = "SELECT count(*) " .
    		"FROM faction " .
    		"WHERE name = '$faction_name'";
    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	$row = mysql_fetch_array( $result, MYSQL_ASSOC );
	if( $row[ 'count(*)' ] > 0 ) {
		$status = "A faction with that name already exists!";
	}
	else {
	    $query = "SELECT count(*) " .
	    		"FROM faction " .
	    		"WHERE tag = '$faction_tag'";
	    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		$row = mysql_fetch_array( $result, MYSQL_ASSOC );
		if( $row[ 'count(*)' ] > 0 ) {
			$status = "A faction with that tag already exists!";
		}
		else {
			if( !isset( $_POST[ 'recruitment' ] ) ) {
				$recruitment = "";
			}
			else {
				$recruitment = formatInput( $_POST[ 'recruitment' ] );
			}
		    $query = "DELETE FROM " .
		    		"faction_member " .
		    		"WHERE ruler_id = " . $_SESSION[ 'ruler_id' ];
		    mysql_query( $query ) or die( "Query failed : " . mysql_error() );
			
		    $query = "INSERT INTO faction " .
		    		"( name, tag, leader, recruitment, faction_type_id ) " .
		    		"VALUES ( '$faction_name', " .
		    		"'$faction_tag', " .
		    		$_SESSION[ 'ruler_id' ] . ", " .
		    		"'" . $recruitment . "', 4 )";
		    mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		    
		    $query = "SELECT faction_id " .
		    		"FROM faction " .
		    		"WHERE name = '$faction_name' AND tag = '$faction_tag'";
		    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
			 $row = mysql_fetch_array( $result, MYSQL_ASSOC );
		    
		    $query = "INSERT INTO faction_member " .
		    		"( ruler_id, member_time, countdown, faction_id, access ) " .
		    		"VALUES ( " . $_SESSION[ 'ruler_id' ] . ", 0, 0, " . $row[ 'faction_id' ] . ", 10 )";
		    mysql_query( $query ) or die( "Query failed : " . mysql_error() );

		    $query = "INSERT INTO chat_channels " .
		    		"( name, group_id ) " .
		    		"VALUES ( 'General', " . $row[ 'faction_id' ] . " )";
		    mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		}
	}
}
else {
	$status = "Fill in a name and tag for your faction.";
}
if( isset( $status ) ) {
	$_SESSION[ 'create_faction_status' ] = $status;
}
header( "Location: ../diplomacy.php" );
?>
